class CreateVideos < ActiveRecord::Migration
  def change
    create_table "videos", :force => true do |t|
      t.string   "name",                                              :null => false
      t.string   "slug",                                               :null => false
      t.text     "body"
      t.text     "summary"
      t.integer  "category_id"
      t.string   "slot"
      t.datetime "published_at"
      t.datetime "created_at"
      t.datetime "updated_at"
      t.string   "kind",              :limit => 10,                    :null => false
      t.datetime "play_at"
      t.integer  "views_count",                     :default => 0
      t.integer  "comments_count",                  :default => 0
      t.integer  "likes_count",                     :default => 0
      t.integer  "checkin_count",                   :default => 0
      t.integer  "clips_count",                     :default => 0
      t.string   "file"
      t.string   "link"
      t.integer  "user_id"
      t.string   "cover"
      t.boolean  "has_clip",                        :default => false
      t.boolean  "published",                       :default => false
      t.string   "period"
      t.string  "zone"
    end

    add_index "videos", :period
    add_index "videos", :kind
    add_index "videos", :category_id
    add_index "videos", :zone
  end
end
